Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# DROP JAVA

Purpose

Use the `DROP` `JAVA` statement to drop a Java source, class, or resource schema object.

See Also: CREATE JAVA for information on creating Java objects Oracle Database Java Developer's Guide for more information on resolving Java sources, classes, and resources

Prerequisites

The Java source, class, or resource must be in your own schema or you must have the `DROP` `ANY` `PROCEDURE` system privilege. You also must have the `EXECUTE` object privilege on Java classes to use this command.

Syntax

drop_java::=

Description of the illustration drop_java.gif

Semantics

JAVA SOURCE

Specify `SOURCE` to drop a Java source schema object and all Java class schema objects derived from it.

JAVA CLASS

Specify `CLASS` to drop a Java class schema object.

JAVA RESOURCE

Specify `RESOURCE` to drop a Java resource schema object.

object_name

Specify the name of an existing Java class, source, or resource schema object. Enclose the `object_name` in double quotation marks to preserve lower- or mixed-case names.

Example

Dropping a Java Class Object: Example The following statement drops the Java class `Agent`, created in "Creating a Java Class Object: Example":

    DROP JAVA CLASS "Agent";